See https://github.com/Kademi/kademi-dev/issues/5404

#set( $crit = $services.criteriaBuilders.points.groupBy("pointsTag").count("id").sum("numPoints") )
#set( $crit = $crit.ge("issuedDate", $services.queryManager.commonStartDate) )
#set( $crit = $crit.lt("issuedDate", $services.queryManager.commonFinishDate) )
#set( $stats = $crit.execute(1000) )

#foreach( $row in $stats )





#end

Tag	Num records	Points
$!row[0].title	$!row[1]	$!row[2]

Eg

controllerMappings
.websiteController()
.path("/mycontroller")
.enabled(true)
.isPublic(true)
.addMethod("POST", "saveOrder")
.postPriviledge("READ_CONTENT")
.build();


function saveOrder(page, params) {
log.info('saveSession > page={}, params={}', page, params);
transactionManager.runInTransaction(function () {

var product = services.criteriaBuilders.get("product").eq("name", "p1").executeSingle();
log.info("product {}", product);

var builder = services.criteriaBuilders.getBuilder("productOrder");
var newOrder = builder.instantiate();
newOrder.product = product;
builder.save(newOrder);
log.info("Created order with ID={}", newOrder.id);
});

return views.jsonView(true, "Saved!");
}

---

Properties

Methods